{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Historical","Sheet2","Datafeed Formula","Locations"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Historical","index":0,"n_rows":29,"n_cols":19,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"Excel Token","eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJmcmVzaCI6ZmFsc2UsImlhdCI6MTY0Nzg3OTQ1NywianRpIjoiZWFiNjk1YTItZjE2Yi00MzhiLWIzNTUtY2E0MjRiMTkzZDY0IiwidHlwZSI6ImFjY2VzcyIsImlkZW50aXR5IjoibmF0aGFuLmhhcnJpc29uQG5hdHVyYWxnYXNpbnRlbC5jb20iLCJuYmYiOjE2NDc4Nzk0NTcsImV4cCI6MTY0Nzk2NTg1N30.SVnNlwWbmTxZ7-xZiN3QVvyC5hTgFtsh60tRq05LCQI"]
[null,"Single Price",{"$f":"[1]!SINGLE_PRICE(H1, \"daily\", \"2022-01-11\", C10)","v":{"$error":"#NAME?"}}]
[]
[]
[null,null,null,null,null,{"$f":"[1]!NGIHistory(H1,C9,C12,C13,C10)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[1]!NGIHistory(H1,C9,C12,C13,C11)","v":{"$error":"#NAME?"}}]
[]
[]
[]
[null,"Series","daily"]
[null,"Point","WTXWAHA","WTXWAHA"]
[null,"Point 2","NEAALGCG"]
[null,"Start Date","2022-01-08"]
[null,"End Date","2022-03-09"]
[]
[]
[]
[]
[null,null,{"$f":"J6","v":0},{"$f":"W6","v":0}]
[null,{"$f":"G6","v":"00:00:00"},{"$f":"_xlfn.NUMBERVALUE(M6)","v":0},{"$f":"_xlfn.NUMBERVALUE(Z6)","v":0}]
[null,{"$f":"G7","v":"00:00:00"},{"$f":"_xlfn.NUMBERVALUE(M7)","v":0},{"$f":"_xlfn.NUMBERVALUE(Z7)","v":0}]
[null,"00:00:00",0,0]
[null,"00:00:00",0,0]
[null,"00:00:00",0,0]
[null,"00:00:00",0,0]
[null,"00:00:00",0,0]
[null,"00:00:00",0,0]
[null,"00:00:00",0,0]
[null,"00:00:00",0,0]
[null,"00:00:00",0,0]

{"sheet":"Sheet2","index":1,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,{"$f":"[1]!NGILocations(Historical!H1, \"mexico-bidweek\")","v":{"$error":"#NAME?"}}]

{"sheet":"Datafeed Formula","index":2,"n_rows":190,"n_cols":12,"rows_kept":190,"cut":false,"hidden":false,"merged":[]}
[{"$f":"NGIDatafeed(Historical!H1,\"daily\",\"2022-03-21\")","v":"Point Code"},"Issue Date","Trade Date","Region","Pricing Point","Low","High","Average","Volume","Deals","Delivery Start Date","Delivery End Date"]
["STXAGUAD","2022-03-21","2022-03-18","South Texas","Agua Dulce","4.000","4.450","4.255","131","10","2022-03-19","2022-03-21"]
["NEAALGCG","2022-03-21","2022-03-18","Northeast","Algonquin Citygate","3.990","4.050","4.030","92","28","2022-03-19","2022-03-21"]
["NEALGNG","2022-03-21","2022-03-18","Northeast","Algonquin Citygate (non-G)","3.990","4.050","4.030","92","28","2022-03-19","2022-03-21"]
["NEAALGIN","2022-03-21","2022-03-18","Northeast","Algonquin Receipts","None","None","None","None","None","2022-03-19","2022-03-21"]
["MCWALL","2022-03-21","2022-03-18","Midwest","Alliance","4.200","4.400","4.305","731","112","2022-03-19","2022-03-21"]
["CDNCREC","2022-03-21","2022-03-18","Canada","Alliance (APC) - ATP","4.450","4.550","4.455","73","24","2022-03-19","2022-03-21"]
["MCWML7","2022-03-21","2022-03-18","Midwest","ANR ML7","None","None","None","None","None","2022-03-19","2022-03-21"]
["SLAANRSE","2022-03-21","2022-03-18","South Louisiana","ANR SE","4.740","4.800","4.785","111","18","2022-03-19","2022-03-21"]
["MCWANR","2022-03-21","2022-03-18","Midcontinent","ANR SW","4.190","4.230","4.215","101","23","2022-03-19","2022-03-21"]
["APPREGAVG","2022-03-21","2022-03-18","Appalachia","Appalachia Regional Avg.","3.700","4.000","3.840","2161","433","2022-03-19","2022-03-21"]
["ETXATMOSZ3","2022-03-21","2022-03-18","East Texas","Atmos Zone 3","4.050","4.150","4.100","10","4","2022-03-19","2022-03-21"]
["STGBOBCAT","2022-03-21","2022-03-18","South Louisiana","Bobcat Storage","None","None","None","None","None","2022-03-19","2022-03-21"]
["CALRAVG","2022-03-21","2022-03-18","California","California Regional Avg.","4.050","5.300","4.295","1793","361","2022-03-19","2022-03-21"]
["ETXCARTH","2022-03-21","2022-03-18","East Texas","Carthage","4.200","4.300","4.245","78","14","2022-03-19","2022-03-21"]
["RMTCHEY","2022-03-21","2022-03-18","Rocky Mountains","Cheyenne Hub","3.875","4.185","4.120","317","54","2022-03-19","2022-03-21"]
["MCWCCNICOR","2022-03-21","2022-03-18","Midwest","Chicago - Nicor Gas","4.490","4.700","4.575","368","56","2022-03-19","2022-03-21"]
["MCWCCNIPS","2022-03-21","2022-03-18","Midwest","Chicago - NIPSCO","4.260","4.320","4.290","243","39","2022-03-19","2022-03-21"]
["MCWCCNSHOR","2022-03-21","2022-03-18","Midwest","Chicago - North Shore","None","None","None","None","None","2022-03-19","2022-03-21"]
["MCWCCPEOP","2022-03-21","2022-03-18","Midwest","Chicago - Peoples","4.250","4.300","4.295","36","17","2022-03-19","2022-03-21"]
["MCWCCITY","2022-03-21","2022-03-18","Midwest","Chicago Citygate","4.250","4.700","4.455","646","112","2022-03-19","2022-03-21"]
["RMTCIG","2022-03-21","2022-03-18","Rocky Mountains","CIG","4.070","4.080","4.075","30","8","2022-03-19","2022-03-21"]
["RMTCIGDJ","2022-03-21","2022-03-18","Rocky Mountains","CIG DJ Basin","4.030","4.060","4.035","7","3","2022-03-19","2022-03-21"]
["NEATCO","2022-03-21","2022-03-18","Appalachia","Columbia Gas","3.870","3.930","3.900","544","97","2022-03-19","2022-03-21"]
["SLACGMAIN","2022-03-21","2022-03-18","South Louisiana","Columbia Gulf Mainline","4.250","4.420","4.345","253","54","2022-03-19","2022-03-21"]
["SLACGO","2022-03-21","2022-03-18","South Louisiana","Columbia Gulf onshore","4.750","4.830","4.775","115","17","2022-03-19","2022-03-21"]
["MCWCONS","2022-03-21","2022-03-18","Midwest","Consumers Energy","4.400","4.500","4.465","336","64","2022-03-19","2022-03-21"]
["NEACOVE","2022-03-21","2022-03-18","Southeast","Cove Point","4.400","4.400","4.400","144","10","2022-03-19","2022-03-21"]
["MCWDAWN","2022-03-21","2022-03-18","Midwest","Dawn","4.530","4.830","4.595","2511","358","2022-03-19","2022-03-21"]
["MCWDEFIANCE","2022-03-21","2022-03-18","Midwest","Defiance","4.200","4.310","4.255","60","12","2022-03-19","2022-03-21"]
["NEADRACUT","2022-03-21","2022-03-18","Northeast","Dracut","None","None","None","None","None","2022-03-19","2022-03-21"]
["NEAEHPITT","2022-03-21","2022-03-18","Northeast","E Hereford/Pittsburg","None","None","None","None","None","2022-03-19","2022-03-21"]
["ETXRAVG","2022-03-21","2022-03-18","East Texas","E. TX Regional Avg.","4.000","4.670","4.255","1378","217","2022-03-19","2022-03-21"]
["NEACNGNP","2022-03-21","2022-03-18","Appalachia","Eastern Gas North","3.830","3.890","3.860","83","28","2022-03-19","2022-03-21"]
["NEACNG","2022-03-21","2022-03-18","Appalachia","Eastern Gas South","3.790","3.860","3.830","425","78","2022-03-19","2022-03-21"]
["STGEGAN","2022-03-21","2022-03-18","South Louisiana","Egan Hub","4.830","4.830","4.830","15","1","2022-03-19","2022-03-21"]
["WTXEPKEY","2022-03-21","2022-03-18","West Texas/SE New Mexico","El Paso - Keystone Pool","3.250","3.720","3.535","172","32","2022-03-19","2022-03-21"]
["WTXEPPL","2022-03-21","2022-03-18","West Texas/SE New Mexico","El Paso - Plains Pool","3.900","3.900","3.900","9","2","2022-03-19","2022-03-21"]
["WTXEPWAHA","2022-03-21","2022-03-18","West Texas/SE New Mexico","El Paso - Waha Pool","3.300","3.700","3.535","303","52","2022-03-19","2022-03-21"]
["MCWEPANDKO","2022-03-21","2022-03-18","Midcontinent","El Paso Anadarko ","4.015","4.050","4.030","70","8","2022-03-19","2022-03-21"]
["RMTEPBON","2022-03-21","2022-03-18","Rocky Mountains","El Paso Bondad","4.070","4.090","4.080","37","10","2022-03-19","2022-03-21"]
["WTXEPP","2022-03-21","2022-03-18","West Texas/SE New Mexico","El Paso Permian","3.250","3.900","3.545","484","86","2022-03-19","2022-03-21"]
["ARNBAJAN","2022-03-21","2022-03-18","Arizona/Nevada","El Paso S. Mainline/N. Baja","4.070","4.260","4.165","65","14","2022-03-19","2022-03-21"]
["RMTEPSJ","2022-03-21","2022-03-18","Rocky Mountains","El Paso San Juan","3.850","4.100","4.075","68","20","2022-03-19","2022-03-21"]
["MCWEMER","2022-03-21","2022-03-18","Midwest","Emerson","4.185","4.270","4.225","256","55","2022-03-19","2022-03-21"]
["CDNEMP","2022-03-21","2022-03-18","Canada","Empress","4.585","4.790","4.655","562","106","2022-03-19","2022-03-21"]
["MCWNORE","2022-03-21","2022-03-18","Midcontinent","Enable East","4.180","4.210","4.195","85","12","2022-03-19","2022-03-21"]
["NLACPTS","2022-03-21","2022-03-18","North Louisiana/Arkansas","Enable South","None","None","None","None","None","2022-03-19","2022-03-21"]
["FLAFGT","2022-03-21","2022-03-18","Southeast","FGT Citygate","5.040","5.280","5.180","None","None","2022-03-19","2022-03-21"]
["STXFGTZ1","2022-03-21","2022-03-18","South Texas","Florida Gas Zone 1","4.570","4.600","4.590","43","3","2022-03-19","2022-03-21"]
["SLAFGTZ2","2022-03-21","2022-03-18","South Louisiana","Florida Gas Zone 2","None","None","None","None","None","2022-03-19","2022-03-21"]
["SLAFGTZ3","2022-03-21","2022-03-18","Southeast","Florida Gas Zone 3","4.700","4.830","4.775","131","22","2022-03-19","2022-03-21"]
["ETXGLDTRI","2022-03-21","2022-03-18","East Texas","Golden Triangle Storage","None","None","None","None","None","2022-03-19","2022-03-21"]
["SLAHH","2022-03-21","2022-03-18","South Louisiana","Henry Hub","4.790","4.900","4.870","711","96","2022-03-19","2022-03-21"]
["ETXHSHIP","2022-03-21","2022-03-18","East Texas","Houston Ship Channel","4.080","4.400","4.260","128","16","2022-03-19","2022-03-21"]
["ETXHPL","2022-03-21","2022-03-18","East Texas","HPL - East Texas Pool","None","None","None","None","None","2022-03-19","2022-03-21"]
["NEAIROZ1","2022-03-21","2022-03-18","Northeast","Iroquois Zone 1","4.350","4.350","4.350","1","2","2022-03-19","2022-03-21"]
["NEAIRO","2022-03-21","2022-03-18","Northeast","Iroquois Zone 2","4.000","4.500","4.205","72","16","2022-03-19","2022-03-21"]
["NEAIROWAD","2022-03-21","2022-03-18","Northeast","Iroquois, Waddington","4.000","4.400","4.290","143","34","2022-03-19","2022-03-21"]
["MCWJOL","2022-03-21","2022-03-18","Midwest","Joliet","4.200","4.400","4.305","731","112","2022-03-19","2022-03-21"]
["ETXKATY","2022-03-21","2022-03-18","East Texas","Katy","4.000","4.170","4.100","426","67","2022-03-19","2022-03-21"]
["RMTKING","2022-03-21","2022-03-18","Rocky Mountains","Kingsgate","4.000","4.040","4.025","29","6","2022-03-19","2022-03-21"]
["ARNKERNDEL","2022-03-21","2022-03-18","Arizona/Nevada","KRGT Del Pool","4.200","4.285","4.260","284","60","2022-03-19","2022-03-21"]
["RMTKR","2022-03-21","2022-03-18","Rocky Mountains","KRGT Rec Pool","4.020","4.200","4.190","340","74","2022-03-19","2022-03-21"]
["NEALEB","2022-03-21","2022-03-18","Midwest","Lebanon","4.170","4.170","4.170","5","2","2022-03-19","2022-03-21"]
["NEALEIDY","2022-03-21","2022-03-18","Appalachia","Leidy Hub","None","None","None","None","None","2022-03-19","2022-03-21"]
["CALM400","2022-03-21","2022-03-18","California","Malin","4.130","4.275","4.245","166","36","2022-03-19","2022-03-21"]
["NEAMNP","2022-03-21","2022-03-18","Northeast","Maritimes & Northeast","None","None","None","None","None","2022-03-19","2022-03-21"]
["OTHMYPRL","2022-03-21","2022-03-18","East Texas","Maypearl","None","None","None","None","None","2022-03-19","2022-03-21"]
["MCWMCON","2022-03-21","2022-03-18","Midwest","Michigan Consolidated","4.450","4.500","4.490","711","115","2022-03-19","2022-03-21"]
["MCTRAVG","2022-03-21","2022-03-18","Midcontinent","Midcontinent Regional Avg.","4.015","4.260","4.165","1593","259","2022-03-19","2022-03-21"]
["MWERAVG","2022-03-21","2022-03-18","Midwest","Midwest Regional Avg.","3.970","4.830","4.325","5885","962","2022-03-19","2022-03-21"]
["NEAMILL","2022-03-21","2022-03-18","Appalachia","Millennium East Pool","3.820","3.850","3.840","27","4","2022-03-19","2022-03-21"]
["ETXMBSF","2022-03-21","2022-03-18","East Texas","Moss Bluff","4.580","4.650","4.615","38","4","2022-03-19","2022-03-21"]
["NLARAVG","2022-03-21","2022-03-18","North Louisiana/Arkansas","N. LA Regional Avg.","4.200","4.400","4.350","1051","180","2022-03-19","2022-03-21"]
["USAVG","2022-03-21","2022-03-18","California","National Avg.","3.250","5.300","4.235","23345","4039","2022-03-19","2022-03-21"]
["MCWNGPLAM","2022-03-21","2022-03-18","Midwest","NGPL Amarillo Mainline","4.170","4.205","4.190","56","14","2022-03-19","2022-03-21"]
["NLANGPLGULFML","2022-03-21","2022-03-18","North Louisiana/Arkansas","NGPL Gulf Coast Mainline","None","None","None","None","None","2022-03-19","2022-03-21"]
["MCWNGPLIOI","2022-03-21","2022-03-18","Midwest","NGPL Iowa-Illinois","4.250","4.255","4.255","30","4","2022-03-19","2022-03-21"]
["MCWNGPLMIDAM","2022-03-21","2022-03-18","Midwest","NGPL MidAmerican","None","None","None","None","None","2022-03-19","2022-03-21"]
["MCWNGPL","2022-03-21","2022-03-18","Midcontinent","NGPL Midcontinent","4.050","4.190","4.165","307","54","2022-03-19","2022-03-21"]
["STXNGPL","2022-03-21","2022-03-18","South Texas","NGPL S. TX","None","None","None","None","None","2022-03-19","2022-03-21"]
["ETXNGPL","2022-03-21","2022-03-18","East Texas","NGPL TexOk","4.110","4.165","4.140","477","66","2022-03-19","2022-03-21"]
["MCWNIAGR","2022-03-21","2022-03-18","Northeast","Niagara","4.050","4.050","4.050","1","1","2022-03-19","2022-03-21"]
["NEARAVG","2022-03-21","2022-03-18","Northeast","Northeast Regional Avg.","3.750","5.000","4.135","618","141","2022-03-19","2022-03-21"]
["MCWNBVENT","2022-03-21","2022-03-18","Midcontinent","Northern Border Ventura","4.100","4.225","4.175","150","24","2022-03-19","2022-03-21"]
["MCWDMARK","2022-03-21","2022-03-18","Midcontinent","Northern Natural Demarc","4.150","4.250","4.200","381","52","2022-03-19","2022-03-21"]
["WTXNNG","2022-03-21","2022-03-18","West Texas/SE New Mexico","Northern Natural Gas 1-7","None","None","None","None","None","2022-03-19","2022-03-21"]
["MCWNNG1316A","2022-03-21","2022-03-18","Midcontinent","Northern Natural Gas 13-16A","None","None","None","None","None","2022-03-19","2022-03-21"]
["MCWNNG812","2022-03-21","2022-03-18","Midcontinent","Northern Natural Gas 8-12","None","None","None","None","None","2022-03-19","2022-03-21"]
["MCWVENT","2022-03-21","2022-03-18","Midcontinent","Northern Natural Ventura","4.190","4.250","4.210","203","30","2022-03-19","2022-03-21"]
["RMTNWSGR","2022-03-21","2022-03-18","Rocky Mountains","Northwest S. of Green River","4.160","4.170","4.165","6","3","2022-03-19","2022-03-21"]
["RMTSUMAS","2022-03-21","2022-03-18","Rocky Mountains","Northwest Sumas","3.800","3.830","3.815","266","70","2022-03-19","2022-03-21"]
["RMTNWW","2022-03-21","2022-03-18","Rocky Mountains","Northwest Wyoming Pool","4.160","4.180","4.170","93","14","2022-03-19","2022-03-21"]
["CDNNOVA","2022-03-21","2022-03-18","Canada","NOVA/AECO C","4.420","4.650","4.500","1911","373","2022-03-19","2022-03-21"]
["MCWONG","2022-03-21","2022-03-18","Midcontinent","OGT","4.100","4.200","4.130","72","10","2022-03-19","2022-03-21"]
["WTXONEOK","2022-03-21","2022-03-18","West Texas/SE New Mexico","Oneok WesTex","3.300","3.700","3.530","87","16","2022-03-19","2022-03-21"]
["RMTOPAL","2022-03-21","2022-03-18","Rocky Mountains","Opal","4.020","4.200","4.190","389","86","2022-03-19","2022-03-21"]
["MCWPEPL","2022-03-21","2022-03-18","Midcontinent","Panhandle Eastern","4.050","4.120","4.105","140","34","2022-03-19","2022-03-21"]
["MCWPARKWAY","2022-03-21","2022-03-18","Midwest","Parkway/Union","4.565","4.830","4.745","181","46","2022-03-19","2022-03-21"]
["NLAPERRY","2022-03-21","2022-03-18","North Louisiana/Arkansas","Perryville","4.350","4.400","4.370","75","11","2022-03-19","2022-03-21"]
["CALPGCG","2022-03-21","2022-03-18","California","PG&E Citygate","5.180","5.300","5.260","779","116","2022-03-19","2022-03-21"]
["SLAPPSF","2022-03-21","2022-03-18","South Louisiana","Pine Prairie","4.720","4.760","4.740","224","44","2022-03-19","2022-03-21"]
["NEAPNGTS","2022-03-21","2022-03-18","Northeast","PNGTS","4.700","5.000","4.850","33","6","2022-03-19","2022-03-21"]
["NEAPNGTSNBDR","2022-03-21","2022-03-18","Northeast","PNGTS Non-Border","4.700","5.000","4.850","33","6","2022-03-19","2022-03-21"]
["RMTQUEST","2022-03-21","2022-03-18","Rocky Mountains","Questar","4.050","4.210","4.185","75","13","2022-03-19","2022-03-21"]
["MCWREXANR","2022-03-21","2022-03-18","Midwest","REX into ANR - Shelby","3.970","4.350","4.235","119","22","2022-03-19","2022-03-21"]
["MCWREXMGT","2022-03-21","2022-03-18","Midwest","REX into MGT - Edgar ","4.180","4.240","4.205","54","12","2022-03-19","2022-03-21"]
["MCWREXNGPL","2022-03-21","2022-03-18","Midwest","REX into NGPL - Moultrie","4.140","4.200","4.185","191","32","2022-03-19","2022-03-21"]
["MCWREXPEPL","2022-03-21","2022-03-18","Midwest","REX into PEPL - Putnam","4.150","4.150","4.150","3","2","2022-03-19","2022-03-21"]
["MCWREXTRNK","2022-03-21","2022-03-18","Midwest","REX into Trunk - Douglas","None","None","None","None","None","2022-03-19","2022-03-21"]
["OTHREXZN3DEL","2022-03-21","2022-03-18","Midwest","REX Zone 3 Delivered","3.970","4.350","4.205","366","68","2022-03-19","2022-03-21"]
["RMTRAVG","2022-03-21","2022-03-18","Rocky Mountains","Rocky Mtns. Regional Avg.","3.800","4.210","4.105","1697","360","2022-03-19","2022-03-21"]
["MCWROVANR","2022-03-21","2022-03-18","Midwest","Rover-ANR","4.250","4.310","4.265","34","8","2022-03-19","2022-03-21"]
["MCWROVPEPL","2022-03-21","2022-03-18","Midwest","Rover-Panhandle","4.200","4.270","4.245","26","4","2022-03-19","2022-03-21"]
["RMTRUBYR","2022-03-21","2022-03-18","Rocky Mountains","Ruby - Receipts","4.175","4.175","4.175","10","2","2022-03-19","2022-03-21"]
["SLARAVG","2022-03-21","2022-03-18","South Louisiana","S. LA Regional Avg.","3.950","4.900","4.685","2940","425","2022-03-19","2022-03-21"]
["STXRAVG","2022-03-21","2022-03-18","South Texas","S. TX Regional Avg.","4.000","4.750","4.430","1137","159","2022-03-19","2022-03-21"]
["CALSAVGBLY","2022-03-21","2022-03-18","California","SoCal Border - Blythe","None","None","None","None","None","2022-03-19","2022-03-21"]
["CALSAVGEH","2022-03-21","2022-03-18","California","SoCal Border - Ehrenberg","4.050","4.200","4.080","148","44","2022-03-19","2022-03-21"]
["CALSAVGKRS","2022-03-21","2022-03-18","California","SoCal Border - Kern River Station","4.200","4.250","4.245","59","13","2022-03-19","2022-03-21"]
["CALSAVGKR","2022-03-21","2022-03-18","California","SoCal Border - Kramer","4.200","4.270","4.245","90","16","2022-03-19","2022-03-21"]
["CALSAVGNE","2022-03-21","2022-03-18","California","SoCal Border - Needles","4.150","4.180","4.160","38","9","2022-03-19","2022-03-21"]
["CALSAVGTPK","2022-03-21","2022-03-18","California","SoCal Border - Topock","4.100","4.180","4.150","82","24","2022-03-19","2022-03-21"]
["CALSAVGWR","2022-03-21","2022-03-18","California","SoCal Border - Wheeler Ridge","None","None","None","None","None","2022-03-19","2022-03-21"]
["CALSAVG","2022-03-21","2022-03-18","California","SoCal Border Avg.","4.050","4.270","4.160","415","106","2022-03-19","2022-03-21"]
["CALSCG","2022-03-21","2022-03-18","California","SoCal Citygate","4.200","4.360","4.290","372","85","2022-03-19","2022-03-21"]
["SEREGAVG","2022-03-21","2022-03-18","Southeast","Southeast Regional Avg.","4.120","5.280","4.580","2091","349","2022-03-19","2022-03-21"]
["CALSPGE","2022-03-21","2022-03-18","California","Southern Border, PG&E","4.100","4.140","4.105","63","18","2022-03-19","2022-03-21"]
["SLASONAT","2022-03-21","2022-03-18","South Louisiana","Southern Natural","4.700","4.805","4.775","649","67","2022-03-19","2022-03-21"]
["ALASPSF","2022-03-21","2022-03-18","Southeast","Southern Pines","None","None","None","None","None","2022-03-19","2022-03-21"]
["MCWWILL","2022-03-21","2022-03-18","Midcontinent","Southern Star","4.150","4.260","4.195","88","12","2022-03-19","2022-03-21"]
["RMTSTAN","2022-03-21","2022-03-18","Rocky Mountains","Stanfield","4.000","4.160","4.115","163","32","2022-03-19","2022-03-21"]
["ALATENN1L100","2022-03-21","2022-03-18","Southeast","Tenn Zone 1 100L","4.120","4.490","4.240","445","69","2022-03-19","2022-03-21"]
["SETENN1OTH","2022-03-21","2022-03-18","Southeast","Tenn Zone 1 non-St. 87","4.120","4.490","4.285","149","27","2022-03-19","2022-03-21"]
["SETENN1ST87","2022-03-21","2022-03-18","Southeast","Tenn Zone 1 St. 87","4.175","4.250","4.215","296","42","2022-03-19","2022-03-21"]
["NEATENN4L200","2022-03-21","2022-03-18","Appalachia","Tenn Zone 4 200L","3.860","3.985","3.905","141","26","2022-03-19","2022-03-21"]
["NEATENN5L200","2022-03-21","2022-03-18","Northeast","Tenn Zone 5 200L","3.750","3.750","3.750","7","1","2022-03-19","2022-03-21"]
["NEATENNZ5E","2022-03-21","2022-03-18","Northeast","Tenn Zone 5 200L East","None","None","None","None","None","2022-03-19","2022-03-21"]
["NEATENNZ5W","2022-03-21","2022-03-18","Northeast","Tenn Zone 5 200L West","3.750","3.750","3.750","7","1","2022-03-19","2022-03-21"]
["NEATENN5L300","2022-03-21","2022-03-18","Northeast","Tenn Zone 5 300L","None","None","None","None","None","2022-03-19","2022-03-21"]
["NEATENN6L200","2022-03-21","2022-03-18","Northeast","Tenn Zone 6 200L","4.000","4.300","4.175","141","18","2022-03-19","2022-03-21"]
["NEATENNZ6N","2022-03-21","2022-03-18","Northeast","Tenn Zone 6 200L North","4.250","4.300","4.300","47","5","2022-03-19","2022-03-21"]
["NEATENNZ6S","2022-03-21","2022-03-18","Northeast","Tenn Zone 6 200L South","4.000","4.150","4.115","94","13","2022-03-19","2022-03-21"]
["NEATENN6L300","2022-03-21","2022-03-18","Northeast","Tenn Zone 6 300L","None","None","None","None","None","2022-03-19","2022-03-21"]
["SLAT500","2022-03-21","2022-03-18","South Louisiana","Tennessee Line 500","4.680","4.775","4.730","210","32","2022-03-19","2022-03-21"]
["SLAT800","2022-03-21","2022-03-18","South Louisiana","Tennessee Line 800","4.690","4.740","4.715","176","24","2022-03-19","2022-03-21"]
["NEATENN4313P","2022-03-21","2022-03-18","Appalachia","Tennessee Zn 4 313 Pool","3.835","3.860","3.845","103","20","2022-03-19","2022-03-21"]
["NEATENN4MAR","2022-03-21","2022-03-18","Appalachia","Tennessee Zn 4 Marcellus","3.700","3.780","3.740","60","20","2022-03-19","2022-03-21"]
["ETXTENN","2022-03-21","2022-03-18","East Texas","Tennessee Zone 0 North","4.140","4.500","4.170","186","38","2022-03-19","2022-03-21"]
["STXTENN","2022-03-21","2022-03-18","South Texas","Tennessee Zone 0 South","4.100","4.400","4.210","262","42","2022-03-19","2022-03-21"]
["SLATETCOE","2022-03-21","2022-03-18","South Louisiana","Texas Eastern E. LA","3.950","4.250","4.190","99","13","2022-03-19","2022-03-21"]
["ETXTETCO","2022-03-21","2022-03-18","East Texas","Texas Eastern E. TX","None","None","None","None","None","2022-03-19","2022-03-21"]
["ALATETM1","2022-03-21","2022-03-18","Southeast","Texas Eastern M-1, 30","4.200","4.200","4.200","8","1","2022-03-19","2022-03-21"]
["NEATETM2DEL","2022-03-21","2022-03-18","Appalachia","Texas Eastern M-2, 30 Delivery","None","None","None","None","None","2022-03-19","2022-03-21"]
["NEATETM2REC","2022-03-21","2022-03-18","Appalachia","Texas Eastern M-2, 30 Receipt","3.740","4.000","3.800","402","80","2022-03-19","2022-03-21"]
["NEATETM3DEL","2022-03-21","2022-03-18","Appalachia","Texas Eastern M-3, Delivery","3.860","3.940","3.890","282","56","2022-03-19","2022-03-21"]
["NEATETM3REC","2022-03-21","2022-03-18","Appalachia","Texas Eastern M-3, Receipt","None","None","None","None","None","2022-03-19","2022-03-21"]
["STXTETCO","2022-03-21","2022-03-18","South Texas","Texas Eastern S. TX","4.560","4.670","4.620","231","30","2022-03-19","2022-03-21"]
["SLATETCOW","2022-03-21","2022-03-18","South Louisiana","Texas Eastern W. LA","4.705","4.780","4.730","198","30","2022-03-19","2022-03-21"]
["ALATETM124","2022-03-21","2022-03-18","North Louisiana/Arkansas","Texas Eastern, M1, 24","None","None","None","None","None","2022-03-19","2022-03-21"]
["ETXTGT","2022-03-21","2022-03-18","North Louisiana/Arkansas","Texas Gas Zone 1","4.200","4.370","4.330","523","97","2022-03-19","2022-03-21"]
["SLATGT","2022-03-21","2022-03-18","South Louisiana","Texas Gas Zone SL","None","None","None","None","None","2022-03-19","2022-03-21"]
["OTHTOLAR","2022-03-21","2022-03-18","East Texas","Tolar Hub","4.040","4.040","4.040","12","4","2022-03-19","2022-03-21"]
["STXST30","2022-03-21","2022-03-18","South Texas","Transco Zone 1","4.350","4.570","4.500","70","23","2022-03-19","2022-03-21"]
["ETXST45","2022-03-21","2022-03-18","East Texas","Transco Zone 2","4.600","4.670","4.615","25","4","2022-03-19","2022-03-21"]
["SLAST65","2022-03-21","2022-03-18","South Louisiana","Transco Zone 3","4.630","4.830","4.745","184","29","2022-03-19","2022-03-21"]
["ALAST85","2022-03-21","2022-03-18","Southeast","Transco Zone 4","4.720","4.820","4.775","1018","176","2022-03-19","2022-03-21"]
["NEATRANZ5","2022-03-21","2022-03-18","Southeast","Transco Zone 5","4.700","4.810","4.770","347","71","2022-03-19","2022-03-21"]
["NEATZ5WGL","2022-03-21","2022-03-18","Southeast","Transco Zone 5 North","4.750","4.800","4.755","6","4","2022-03-19","2022-03-21"]
["NEATZ5NWGL","2022-03-21","2022-03-18","Southeast","Transco Zone 5 South","4.700","4.810","4.770","342","67","2022-03-19","2022-03-21"]
["NEATZ6NNY","2022-03-21","2022-03-18","Northeast","Transco Zone 6 non-NY","3.800","3.810","3.805","94","24","2022-03-19","2022-03-21"]
["NEATZ6NNYN","2022-03-21","2022-03-18","Northeast","Transco Zone 6 non-NY North","3.800","3.810","3.805","94","24","2022-03-19","2022-03-21"]
["NEATZ6NNYS","2022-03-21","2022-03-18","Northeast","Transco Zone 6 non-NY South","None","None","None","None","None","2022-03-19","2022-03-21"]
["NEATZ6NY","2022-03-21","2022-03-18","Northeast","Transco Zone 6 NY","3.800","3.900","3.820","36","11","2022-03-19","2022-03-21"]
["NEALEIDYT","2022-03-21","2022-03-18","Appalachia","Transco-Leidy Line","3.770","3.790","3.775","98","24","2022-03-19","2022-03-21"]
["WTXTW","2022-03-21","2022-03-18","West Texas/SE New Mexico","Transwestern","3.400","3.700","3.690","11","4","2022-03-19","2022-03-21"]
["WTXTWCENT","2022-03-21","2022-03-18","West Texas/SE New Mexico","Transwestern - Central","None","None","None","None","None","2022-03-19","2022-03-21"]
["WTXTWOTH","2022-03-21","2022-03-18","West Texas/SE New Mexico","Transwestern - W. TX","3.400","3.700","3.690","11","4","2022-03-19","2022-03-21"]
["OTHTWPAN","2022-03-21","2022-03-18","Midcontinent","Transwestern Panhandle Pool","None","None","None","None","None","2022-03-19","2022-03-21"]
["RMTTWSJ","2022-03-21","2022-03-18","Rocky Mountains","Transwestern San Juan","4.050","4.100","4.085","61","13","2022-03-19","2022-03-21"]
["STX3PAL","2022-03-21","2022-03-18","South Texas","Tres Palacios","4.150","4.750","4.405","401","51","2022-03-19","2022-03-21"]
["SLATRNKE","2022-03-21","2022-03-18","South Louisiana","Trunkline E. LA","None","None","None","None","None","2022-03-19","2022-03-21"]
["SLATRNKW","2022-03-21","2022-03-18","South Louisiana","Trunkline W. LA","None","None","None","None","None","2022-03-19","2022-03-21"]
["OTHTRNK1A","2022-03-21","2022-03-18","North Louisiana/Arkansas","Trunkline Zone 1A","4.250","4.400","4.350","454","72","2022-03-19","2022-03-21"]
["OTHVENTURA","2022-03-21","2022-03-18","Midcontinent","Ventura","4.100","4.250","4.195","353","54","2022-03-19","2022-03-21"]
["WTXRAVG","2022-03-21","2022-03-18","West Texas/SE New Mexico","W. TX/SE NM Regional Avg.","3.250","3.900","3.620","658","119","2022-03-19","2022-03-21"]
["WTXWAHA","2022-03-21","2022-03-18","West Texas/SE New Mexico","Waha","3.300","3.700","3.545","467","81","2022-03-19","2022-03-21"]
["CDNWST2","2022-03-21","2022-03-18","Canada","Westcoast Station 2","4.340","4.400","4.355","136","41","2022-03-19","2022-03-21"]
["RMTWHITERVR","2022-03-21","2022-03-18","Rocky Mountains","White River Hub","3.950","4.200","4.160","149","26","2022-03-19","2022-03-21"]

{"sheet":"Locations","index":3,"n_rows":190,"n_cols":2,"rows_kept":190,"cut":false,"hidden":false,"merged":[]}
[{"$f":"NGILocations(Historical!H1, \"daily\")","v":"Pricing Point"},"Point Code"]
["Agua Dulce","STXAGUAD"]
["Algonquin Citygate","NEAALGCG"]
["Algonquin Citygate (non-G)","NEALGNG"]
["Algonquin Receipts","NEAALGIN"]
["Alliance","MCWALL"]
["Alliance (APC) - ATP","CDNCREC"]
["ANR ML7","MCWML7"]
["ANR SE","SLAANRSE"]
["ANR SW","MCWANR"]
["Appalachia Regional Avg.","APPREGAVG"]
["Atmos Zone 3","ETXATMOSZ3"]
["Bobcat Storage","STGBOBCAT"]
["California Regional Avg.","CALRAVG"]
["Carthage","ETXCARTH"]
["Cheyenne Hub","RMTCHEY"]
["Chicago - Nicor Gas","MCWCCNICOR"]
["Chicago - NIPSCO","MCWCCNIPS"]
["Chicago - North Shore","MCWCCNSHOR"]
["Chicago - Peoples","MCWCCPEOP"]
["Chicago Citygate","MCWCCITY"]
["CIG","RMTCIG"]
["CIG DJ Basin","RMTCIGDJ"]
["Columbia Gas","NEATCO"]
["Columbia Gulf Mainline","SLACGMAIN"]
["Columbia Gulf onshore","SLACGO"]
["Consumers Energy","MCWCONS"]
["Cove Point","NEACOVE"]
["Dawn","MCWDAWN"]
["Defiance","MCWDEFIANCE"]
["Dracut","NEADRACUT"]
["E Hereford/Pittsburg","NEAEHPITT"]
["E. TX Regional Avg.","ETXRAVG"]
["Eastern Gas North","NEACNGNP"]
["Eastern Gas South","NEACNG"]
["Egan Hub","STGEGAN"]
["El Paso - Keystone Pool","WTXEPKEY"]
["El Paso - Plains Pool","WTXEPPL"]
["El Paso - Waha Pool","WTXEPWAHA"]
["El Paso Anadarko ","MCWEPANDKO"]
["El Paso Bondad","RMTEPBON"]
["El Paso Permian","WTXEPP"]
["El Paso S. Mainline/N. Baja","ARNBAJAN"]
["El Paso San Juan","RMTEPSJ"]
["Emerson","MCWEMER"]
["Empress","CDNEMP"]
["Enable East","MCWNORE"]
["Enable South","NLACPTS"]
["FGT Citygate","FLAFGT"]
["Florida Gas Zone 1","STXFGTZ1"]
["Florida Gas Zone 2","SLAFGTZ2"]
["Florida Gas Zone 3","SLAFGTZ3"]
["Golden Triangle Storage","ETXGLDTRI"]
["Henry Hub","SLAHH"]
["Houston Ship Channel","ETXHSHIP"]
["HPL - East Texas Pool","ETXHPL"]
["Iroquois Zone 1","NEAIROZ1"]
["Iroquois Zone 2","NEAIRO"]
["Iroquois, Waddington","NEAIROWAD"]
["Joliet","MCWJOL"]
["Katy","ETXKATY"]
["Kingsgate","RMTKING"]
["KRGT Del Pool","ARNKERNDEL"]
["KRGT Rec Pool","RMTKR"]
["Lebanon","NEALEB"]
["Leidy Hub","NEALEIDY"]
["Malin","CALM400"]
["Maritimes & Northeast","NEAMNP"]
["Maypearl","OTHMYPRL"]
["Michigan Consolidated","MCWMCON"]
["Midcontinent Regional Avg.","MCTRAVG"]
["Midwest Regional Avg.","MWERAVG"]
["Millennium East Pool","NEAMILL"]
["Moss Bluff","ETXMBSF"]
["N. LA Regional Avg.","NLARAVG"]
["National Avg.","USAVG"]
["NGPL Amarillo Mainline","MCWNGPLAM"]
["NGPL Gulf Coast Mainline","NLANGPLGULFML"]
["NGPL Iowa-Illinois","MCWNGPLIOI"]
["NGPL MidAmerican","MCWNGPLMIDAM"]
["NGPL Midcontinent","MCWNGPL"]
["NGPL S. TX","STXNGPL"]
["NGPL TexOk","ETXNGPL"]
["Niagara","MCWNIAGR"]
["Northeast Regional Avg.","NEARAVG"]
["Northern Border Ventura","MCWNBVENT"]
["Northern Natural Demarc","MCWDMARK"]
["Northern Natural Gas 1-7","WTXNNG"]
["Northern Natural Gas 13-16A","MCWNNG1316A"]
["Northern Natural Gas 8-12","MCWNNG812"]
["Northern Natural Ventura","MCWVENT"]
["Northwest S. of Green River","RMTNWSGR"]
["Northwest Sumas","RMTSUMAS"]
["Northwest Wyoming Pool","RMTNWW"]
["NOVA/AECO C","CDNNOVA"]
["OGT","MCWONG"]
["Oneok WesTex","WTXONEOK"]
["Opal","RMTOPAL"]
["Panhandle Eastern","MCWPEPL"]
["Parkway/Union","MCWPARKWAY"]
["Perryville","NLAPERRY"]
["PG&E Citygate","CALPGCG"]
["Pine Prairie","SLAPPSF"]
["PNGTS","NEAPNGTS"]
["PNGTS Non-Border","NEAPNGTSNBDR"]
["Questar","RMTQUEST"]
["REX into ANR - Shelby","MCWREXANR"]
["REX into MGT - Edgar ","MCWREXMGT"]
["REX into NGPL - Moultrie","MCWREXNGPL"]
["REX into PEPL - Putnam","MCWREXPEPL"]
["REX into Trunk - Douglas","MCWREXTRNK"]
["REX Zone 3 Delivered","OTHREXZN3DEL"]
["Rocky Mtns. Regional Avg.","RMTRAVG"]
["Rover-ANR","MCWROVANR"]
["Rover-Panhandle","MCWROVPEPL"]
["Ruby - Receipts","RMTRUBYR"]
["S. LA Regional Avg.","SLARAVG"]
["S. TX Regional Avg.","STXRAVG"]
["SoCal Border - Blythe","CALSAVGBLY"]
["SoCal Border - Ehrenberg","CALSAVGEH"]
["SoCal Border - Kern River Station","CALSAVGKRS"]
["SoCal Border - Kramer","CALSAVGKR"]
["SoCal Border - Needles","CALSAVGNE"]
["SoCal Border - Topock","CALSAVGTPK"]
["SoCal Border - Wheeler Ridge","CALSAVGWR"]
["SoCal Border Avg.","CALSAVG"]
["SoCal Citygate","CALSCG"]
["Southeast Regional Avg.","SEREGAVG"]
["Southern Border, PG&E","CALSPGE"]
["Southern Natural","SLASONAT"]
["Southern Pines","ALASPSF"]
["Southern Star","MCWWILL"]
["Stanfield","RMTSTAN"]
["Tenn Zone 1 100L","ALATENN1L100"]
["Tenn Zone 1 non-St. 87","SETENN1OTH"]
["Tenn Zone 1 St. 87","SETENN1ST87"]
["Tenn Zone 4 200L","NEATENN4L200"]
["Tenn Zone 5 200L","NEATENN5L200"]
["Tenn Zone 5 200L East","NEATENNZ5E"]
["Tenn Zone 5 200L West","NEATENNZ5W"]
["Tenn Zone 5 300L","NEATENN5L300"]
["Tenn Zone 6 200L","NEATENN6L200"]
["Tenn Zone 6 200L North","NEATENNZ6N"]
["Tenn Zone 6 200L South","NEATENNZ6S"]
["Tenn Zone 6 300L","NEATENN6L300"]
["Tennessee Line 500","SLAT500"]
["Tennessee Line 800","SLAT800"]
["Tennessee Zn 4 313 Pool","NEATENN4313P"]
["Tennessee Zn 4 Marcellus","NEATENN4MAR"]
["Tennessee Zone 0 North","ETXTENN"]
["Tennessee Zone 0 South","STXTENN"]
["Texas Eastern E. LA","SLATETCOE"]
["Texas Eastern E. TX","ETXTETCO"]
["Texas Eastern M-1, 30","ALATETM1"]
["Texas Eastern M-2, 30 Delivery","NEATETM2DEL"]
["Texas Eastern M-2, 30 Receipt","NEATETM2REC"]
["Texas Eastern M-3, Delivery","NEATETM3DEL"]
["Texas Eastern M-3, Receipt","NEATETM3REC"]
["Texas Eastern S. TX","STXTETCO"]
["Texas Eastern W. LA","SLATETCOW"]
["Texas Eastern, M1, 24","ALATETM124"]
["Texas Gas Zone 1","ETXTGT"]
["Texas Gas Zone SL","SLATGT"]
["Tolar Hub","OTHTOLAR"]
["Transco Zone 1","STXST30"]
["Transco Zone 2","ETXST45"]
["Transco Zone 3","SLAST65"]
["Transco Zone 4","ALAST85"]
["Transco Zone 5","NEATRANZ5"]
["Transco Zone 5 North","NEATZ5WGL"]
["Transco Zone 5 South","NEATZ5NWGL"]
["Transco Zone 6 non-NY","NEATZ6NNY"]
["Transco Zone 6 non-NY North","NEATZ6NNYN"]
["Transco Zone 6 non-NY South","NEATZ6NNYS"]
["Transco Zone 6 NY","NEATZ6NY"]
["Transco-Leidy Line","NEALEIDYT"]
["Transwestern","WTXTW"]
["Transwestern - Central","WTXTWCENT"]
["Transwestern - W. TX","WTXTWOTH"]
["Transwestern Panhandle Pool","OTHTWPAN"]
["Transwestern San Juan","RMTTWSJ"]
["Tres Palacios","STX3PAL"]
["Trunkline E. LA","SLATRNKE"]
["Trunkline W. LA","SLATRNKW"]
["Trunkline Zone 1A","OTHTRNK1A"]
["Ventura","OTHVENTURA"]
["W. TX/SE NM Regional Avg.","WTXRAVG"]
["Waha","WTXWAHA"]
["Westcoast Station 2","CDNWST2"]
["White River Hub","RMTWHITERVR"]